Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
CustomerMembeshiprProgramAccountID (PK) | Token ID for a CustomerMemberProgramAccount. | ID_CT_MBR_PRGM_ACNT | Identity | integer | |
CustomerAccountID (FK) | A unique identifier for a customer account. | ID_CTAC | Identity | integer | CustomerMembershipAccount(LE_CT_MBRSHP_ACNT) |
EffectiveDate | Date a CustomerRewardAccount becomes active. | DC_EF_DT | EffectiveDate | date | |
ExpirationDate | Date a CustomerRewardProgramAccount becomes inactive | DC_EP_DT | ExpirationDate | date | |
StatusCode | Current status of this CustomerRewardProgramAccount Valid values are A Active I Inactive | CD_STS | Code2Status | char(2) | |
MembershipProgramID (FK) | Token ID for a CustomerRewardProgram instance. | ID_CT_MBRSHP_PRGM | Identity | integer | CustomerMembershipProgramLevel(CO_CT_MBRSHP_PRGM_LV) |
LevelNumber (FK) | A whole number that establishes the relative value of a membership program level. The higher the value, the greater the level and its associated rewards and, where applicable, fees. | IC_LV_NMB | Number | integer | CustomerMembershipProgramLevel(CO_CT_MBRSHP_PRGM_LV) |